package com.leesche.zcsp.node.web.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SysFirmWareCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SysFirmWareCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFirmwareidIsNull() {
            addCriterion("FirmWareId is null");
            return (Criteria) this;
        }

        public Criteria andFirmwareidIsNotNull() {
            addCriterion("FirmWareId is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwareidEqualTo(Long value) {
            addCriterion("FirmWareId =", value, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidNotEqualTo(Long value) {
            addCriterion("FirmWareId <>", value, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidGreaterThan(Long value) {
            addCriterion("FirmWareId >", value, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidGreaterThanOrEqualTo(Long value) {
            addCriterion("FirmWareId >=", value, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidLessThan(Long value) {
            addCriterion("FirmWareId <", value, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidLessThanOrEqualTo(Long value) {
            addCriterion("FirmWareId <=", value, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidIn(List<Long> values) {
            addCriterion("FirmWareId in", values, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidNotIn(List<Long> values) {
            addCriterion("FirmWareId not in", values, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidBetween(Long value1, Long value2) {
            addCriterion("FirmWareId between", value1, value2, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwareidNotBetween(Long value1, Long value2) {
            addCriterion("FirmWareId not between", value1, value2, "firmwareid");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameIsNull() {
            addCriterion("FirmWareName is null");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameIsNotNull() {
            addCriterion("FirmWareName is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameEqualTo(String value) {
            addCriterion("FirmWareName =", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameNotEqualTo(String value) {
            addCriterion("FirmWareName <>", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameGreaterThan(String value) {
            addCriterion("FirmWareName >", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameGreaterThanOrEqualTo(String value) {
            addCriterion("FirmWareName >=", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameLessThan(String value) {
            addCriterion("FirmWareName <", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameLessThanOrEqualTo(String value) {
            addCriterion("FirmWareName <=", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameLike(String value) {
            addCriterion("FirmWareName like", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameNotLike(String value) {
            addCriterion("FirmWareName not like", value, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameIn(List<String> values) {
            addCriterion("FirmWareName in", values, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameNotIn(List<String> values) {
            addCriterion("FirmWareName not in", values, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameBetween(String value1, String value2) {
            addCriterion("FirmWareName between", value1, value2, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwarenameNotBetween(String value1, String value2) {
            addCriterion("FirmWareName not between", value1, value2, "firmwarename");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleIsNull() {
            addCriterion("FirmWareTitle is null");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleIsNotNull() {
            addCriterion("FirmWareTitle is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleEqualTo(String value) {
            addCriterion("FirmWareTitle =", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleNotEqualTo(String value) {
            addCriterion("FirmWareTitle <>", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleGreaterThan(String value) {
            addCriterion("FirmWareTitle >", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleGreaterThanOrEqualTo(String value) {
            addCriterion("FirmWareTitle >=", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleLessThan(String value) {
            addCriterion("FirmWareTitle <", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleLessThanOrEqualTo(String value) {
            addCriterion("FirmWareTitle <=", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleLike(String value) {
            addCriterion("FirmWareTitle like", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleNotLike(String value) {
            addCriterion("FirmWareTitle not like", value, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleIn(List<String> values) {
            addCriterion("FirmWareTitle in", values, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleNotIn(List<String> values) {
            addCriterion("FirmWareTitle not in", values, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleBetween(String value1, String value2) {
            addCriterion("FirmWareTitle between", value1, value2, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwaretitleNotBetween(String value1, String value2) {
            addCriterion("FirmWareTitle not between", value1, value2, "firmwaretitle");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentIsNull() {
            addCriterion("FirmWareContent is null");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentIsNotNull() {
            addCriterion("FirmWareContent is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentEqualTo(String value) {
            addCriterion("FirmWareContent =", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentNotEqualTo(String value) {
            addCriterion("FirmWareContent <>", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentGreaterThan(String value) {
            addCriterion("FirmWareContent >", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentGreaterThanOrEqualTo(String value) {
            addCriterion("FirmWareContent >=", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentLessThan(String value) {
            addCriterion("FirmWareContent <", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentLessThanOrEqualTo(String value) {
            addCriterion("FirmWareContent <=", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentLike(String value) {
            addCriterion("FirmWareContent like", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentNotLike(String value) {
            addCriterion("FirmWareContent not like", value, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentIn(List<String> values) {
            addCriterion("FirmWareContent in", values, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentNotIn(List<String> values) {
            addCriterion("FirmWareContent not in", values, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentBetween(String value1, String value2) {
            addCriterion("FirmWareContent between", value1, value2, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andFirmwarecontentNotBetween(String value1, String value2) {
            addCriterion("FirmWareContent not between", value1, value2, "firmwarecontent");
            return (Criteria) this;
        }

        public Criteria andBigversionIsNull() {
            addCriterion("bigVersion is null");
            return (Criteria) this;
        }

        public Criteria andBigversionIsNotNull() {
            addCriterion("bigVersion is not null");
            return (Criteria) this;
        }

        public Criteria andBigversionEqualTo(Integer value) {
            addCriterion("bigVersion =", value, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionNotEqualTo(Integer value) {
            addCriterion("bigVersion <>", value, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionGreaterThan(Integer value) {
            addCriterion("bigVersion >", value, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionGreaterThanOrEqualTo(Integer value) {
            addCriterion("bigVersion >=", value, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionLessThan(Integer value) {
            addCriterion("bigVersion <", value, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionLessThanOrEqualTo(Integer value) {
            addCriterion("bigVersion <=", value, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionIn(List<Integer> values) {
            addCriterion("bigVersion in", values, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionNotIn(List<Integer> values) {
            addCriterion("bigVersion not in", values, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionBetween(Integer value1, Integer value2) {
            addCriterion("bigVersion between", value1, value2, "bigversion");
            return (Criteria) this;
        }

        public Criteria andBigversionNotBetween(Integer value1, Integer value2) {
            addCriterion("bigVersion not between", value1, value2, "bigversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionIsNull() {
            addCriterion("litterVersion is null");
            return (Criteria) this;
        }

        public Criteria andLitterversionIsNotNull() {
            addCriterion("litterVersion is not null");
            return (Criteria) this;
        }

        public Criteria andLitterversionEqualTo(Integer value) {
            addCriterion("litterVersion =", value, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionNotEqualTo(Integer value) {
            addCriterion("litterVersion <>", value, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionGreaterThan(Integer value) {
            addCriterion("litterVersion >", value, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionGreaterThanOrEqualTo(Integer value) {
            addCriterion("litterVersion >=", value, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionLessThan(Integer value) {
            addCriterion("litterVersion <", value, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionLessThanOrEqualTo(Integer value) {
            addCriterion("litterVersion <=", value, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionIn(List<Integer> values) {
            addCriterion("litterVersion in", values, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionNotIn(List<Integer> values) {
            addCriterion("litterVersion not in", values, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionBetween(Integer value1, Integer value2) {
            addCriterion("litterVersion between", value1, value2, "litterversion");
            return (Criteria) this;
        }

        public Criteria andLitterversionNotBetween(Integer value1, Integer value2) {
            addCriterion("litterVersion not between", value1, value2, "litterversion");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgIsNull() {
            addCriterion("FirmWareImg is null");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgIsNotNull() {
            addCriterion("FirmWareImg is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgEqualTo(String value) {
            addCriterion("FirmWareImg =", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgNotEqualTo(String value) {
            addCriterion("FirmWareImg <>", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgGreaterThan(String value) {
            addCriterion("FirmWareImg >", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgGreaterThanOrEqualTo(String value) {
            addCriterion("FirmWareImg >=", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgLessThan(String value) {
            addCriterion("FirmWareImg <", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgLessThanOrEqualTo(String value) {
            addCriterion("FirmWareImg <=", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgLike(String value) {
            addCriterion("FirmWareImg like", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgNotLike(String value) {
            addCriterion("FirmWareImg not like", value, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgIn(List<String> values) {
            addCriterion("FirmWareImg in", values, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgNotIn(List<String> values) {
            addCriterion("FirmWareImg not in", values, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgBetween(String value1, String value2) {
            addCriterion("FirmWareImg between", value1, value2, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareimgNotBetween(String value1, String value2) {
            addCriterion("FirmWareImg not between", value1, value2, "firmwareimg");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlIsNull() {
            addCriterion("FirmWareURL is null");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlIsNotNull() {
            addCriterion("FirmWareURL is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlEqualTo(String value) {
            addCriterion("FirmWareURL =", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlNotEqualTo(String value) {
            addCriterion("FirmWareURL <>", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlGreaterThan(String value) {
            addCriterion("FirmWareURL >", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlGreaterThanOrEqualTo(String value) {
            addCriterion("FirmWareURL >=", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlLessThan(String value) {
            addCriterion("FirmWareURL <", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlLessThanOrEqualTo(String value) {
            addCriterion("FirmWareURL <=", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlLike(String value) {
            addCriterion("FirmWareURL like", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlNotLike(String value) {
            addCriterion("FirmWareURL not like", value, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlIn(List<String> values) {
            addCriterion("FirmWareURL in", values, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlNotIn(List<String> values) {
            addCriterion("FirmWareURL not in", values, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlBetween(String value1, String value2) {
            addCriterion("FirmWareURL between", value1, value2, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwareurlNotBetween(String value1, String value2) {
            addCriterion("FirmWareURL not between", value1, value2, "firmwareurl");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeIsNull() {
            addCriterion("FirmWareType is null");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeIsNotNull() {
            addCriterion("FirmWareType is not null");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeEqualTo(Integer value) {
            addCriterion("FirmWareType =", value, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeNotEqualTo(Integer value) {
            addCriterion("FirmWareType <>", value, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeGreaterThan(Integer value) {
            addCriterion("FirmWareType >", value, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("FirmWareType >=", value, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeLessThan(Integer value) {
            addCriterion("FirmWareType <", value, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeLessThanOrEqualTo(Integer value) {
            addCriterion("FirmWareType <=", value, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeIn(List<Integer> values) {
            addCriterion("FirmWareType in", values, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeNotIn(List<Integer> values) {
            addCriterion("FirmWareType not in", values, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeBetween(Integer value1, Integer value2) {
            addCriterion("FirmWareType between", value1, value2, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andFirmwaretypeNotBetween(Integer value1, Integer value2) {
            addCriterion("FirmWareType not between", value1, value2, "firmwaretype");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeIsNull() {
            addCriterion("UpdateRange is null");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeIsNotNull() {
            addCriterion("UpdateRange is not null");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeEqualTo(Integer value) {
            addCriterion("UpdateRange =", value, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeNotEqualTo(Integer value) {
            addCriterion("UpdateRange <>", value, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeGreaterThan(Integer value) {
            addCriterion("UpdateRange >", value, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeGreaterThanOrEqualTo(Integer value) {
            addCriterion("UpdateRange >=", value, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeLessThan(Integer value) {
            addCriterion("UpdateRange <", value, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeLessThanOrEqualTo(Integer value) {
            addCriterion("UpdateRange <=", value, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeIn(List<Integer> values) {
            addCriterion("UpdateRange in", values, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeNotIn(List<Integer> values) {
            addCriterion("UpdateRange not in", values, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeBetween(Integer value1, Integer value2) {
            addCriterion("UpdateRange between", value1, value2, "updaterange");
            return (Criteria) this;
        }

        public Criteria andUpdaterangeNotBetween(Integer value1, Integer value2) {
            addCriterion("UpdateRange not between", value1, value2, "updaterange");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidIsNull() {
            addCriterion("deviceTypeId is null");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidIsNotNull() {
            addCriterion("deviceTypeId is not null");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidEqualTo(Long value) {
            addCriterion("deviceTypeId =", value, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidNotEqualTo(Long value) {
            addCriterion("deviceTypeId <>", value, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidGreaterThan(Long value) {
            addCriterion("deviceTypeId >", value, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidGreaterThanOrEqualTo(Long value) {
            addCriterion("deviceTypeId >=", value, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidLessThan(Long value) {
            addCriterion("deviceTypeId <", value, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidLessThanOrEqualTo(Long value) {
            addCriterion("deviceTypeId <=", value, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidIn(List<Long> values) {
            addCriterion("deviceTypeId in", values, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidNotIn(List<Long> values) {
            addCriterion("deviceTypeId not in", values, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidBetween(Long value1, Long value2) {
            addCriterion("deviceTypeId between", value1, value2, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andDevicetypeidNotBetween(Long value1, Long value2) {
            addCriterion("deviceTypeId not between", value1, value2, "devicetypeid");
            return (Criteria) this;
        }

        public Criteria andSdata1IsNull() {
            addCriterion("sData1 is null");
            return (Criteria) this;
        }

        public Criteria andSdata1IsNotNull() {
            addCriterion("sData1 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata1EqualTo(String value) {
            addCriterion("sData1 =", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotEqualTo(String value) {
            addCriterion("sData1 <>", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1GreaterThan(String value) {
            addCriterion("sData1 >", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1GreaterThanOrEqualTo(String value) {
            addCriterion("sData1 >=", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1LessThan(String value) {
            addCriterion("sData1 <", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1LessThanOrEqualTo(String value) {
            addCriterion("sData1 <=", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1Like(String value) {
            addCriterion("sData1 like", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotLike(String value) {
            addCriterion("sData1 not like", value, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1In(List<String> values) {
            addCriterion("sData1 in", values, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotIn(List<String> values) {
            addCriterion("sData1 not in", values, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1Between(String value1, String value2) {
            addCriterion("sData1 between", value1, value2, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata1NotBetween(String value1, String value2) {
            addCriterion("sData1 not between", value1, value2, "sdata1");
            return (Criteria) this;
        }

        public Criteria andSdata2IsNull() {
            addCriterion("sData2 is null");
            return (Criteria) this;
        }

        public Criteria andSdata2IsNotNull() {
            addCriterion("sData2 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata2EqualTo(String value) {
            addCriterion("sData2 =", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2NotEqualTo(String value) {
            addCriterion("sData2 <>", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2GreaterThan(String value) {
            addCriterion("sData2 >", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2GreaterThanOrEqualTo(String value) {
            addCriterion("sData2 >=", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2LessThan(String value) {
            addCriterion("sData2 <", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2LessThanOrEqualTo(String value) {
            addCriterion("sData2 <=", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2Like(String value) {
            addCriterion("sData2 like", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2NotLike(String value) {
            addCriterion("sData2 not like", value, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2In(List<String> values) {
            addCriterion("sData2 in", values, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2NotIn(List<String> values) {
            addCriterion("sData2 not in", values, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2Between(String value1, String value2) {
            addCriterion("sData2 between", value1, value2, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata2NotBetween(String value1, String value2) {
            addCriterion("sData2 not between", value1, value2, "sdata2");
            return (Criteria) this;
        }

        public Criteria andSdata3IsNull() {
            addCriterion("sData3 is null");
            return (Criteria) this;
        }

        public Criteria andSdata3IsNotNull() {
            addCriterion("sData3 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata3EqualTo(String value) {
            addCriterion("sData3 =", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotEqualTo(String value) {
            addCriterion("sData3 <>", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3GreaterThan(String value) {
            addCriterion("sData3 >", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3GreaterThanOrEqualTo(String value) {
            addCriterion("sData3 >=", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3LessThan(String value) {
            addCriterion("sData3 <", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3LessThanOrEqualTo(String value) {
            addCriterion("sData3 <=", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3Like(String value) {
            addCriterion("sData3 like", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotLike(String value) {
            addCriterion("sData3 not like", value, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3In(List<String> values) {
            addCriterion("sData3 in", values, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotIn(List<String> values) {
            addCriterion("sData3 not in", values, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3Between(String value1, String value2) {
            addCriterion("sData3 between", value1, value2, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata3NotBetween(String value1, String value2) {
            addCriterion("sData3 not between", value1, value2, "sdata3");
            return (Criteria) this;
        }

        public Criteria andSdata4IsNull() {
            addCriterion("sData4 is null");
            return (Criteria) this;
        }

        public Criteria andSdata4IsNotNull() {
            addCriterion("sData4 is not null");
            return (Criteria) this;
        }

        public Criteria andSdata4EqualTo(String value) {
            addCriterion("sData4 =", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotEqualTo(String value) {
            addCriterion("sData4 <>", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4GreaterThan(String value) {
            addCriterion("sData4 >", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4GreaterThanOrEqualTo(String value) {
            addCriterion("sData4 >=", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4LessThan(String value) {
            addCriterion("sData4 <", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4LessThanOrEqualTo(String value) {
            addCriterion("sData4 <=", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4Like(String value) {
            addCriterion("sData4 like", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotLike(String value) {
            addCriterion("sData4 not like", value, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4In(List<String> values) {
            addCriterion("sData4 in", values, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotIn(List<String> values) {
            addCriterion("sData4 not in", values, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4Between(String value1, String value2) {
            addCriterion("sData4 between", value1, value2, "sdata4");
            return (Criteria) this;
        }

        public Criteria andSdata4NotBetween(String value1, String value2) {
            addCriterion("sData4 not between", value1, value2, "sdata4");
            return (Criteria) this;
        }

        public Criteria andIdata1IsNull() {
            addCriterion("iData1 is null");
            return (Criteria) this;
        }

        public Criteria andIdata1IsNotNull() {
            addCriterion("iData1 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata1EqualTo(Integer value) {
            addCriterion("iData1 =", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1NotEqualTo(Integer value) {
            addCriterion("iData1 <>", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1GreaterThan(Integer value) {
            addCriterion("iData1 >", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1GreaterThanOrEqualTo(Integer value) {
            addCriterion("iData1 >=", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1LessThan(Integer value) {
            addCriterion("iData1 <", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1LessThanOrEqualTo(Integer value) {
            addCriterion("iData1 <=", value, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1In(List<Integer> values) {
            addCriterion("iData1 in", values, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1NotIn(List<Integer> values) {
            addCriterion("iData1 not in", values, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1Between(Integer value1, Integer value2) {
            addCriterion("iData1 between", value1, value2, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata1NotBetween(Integer value1, Integer value2) {
            addCriterion("iData1 not between", value1, value2, "idata1");
            return (Criteria) this;
        }

        public Criteria andIdata2IsNull() {
            addCriterion("idata2 is null");
            return (Criteria) this;
        }

        public Criteria andIdata2IsNotNull() {
            addCriterion("idata2 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata2EqualTo(Integer value) {
            addCriterion("idata2 =", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2NotEqualTo(Integer value) {
            addCriterion("idata2 <>", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2GreaterThan(Integer value) {
            addCriterion("idata2 >", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2GreaterThanOrEqualTo(Integer value) {
            addCriterion("idata2 >=", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2LessThan(Integer value) {
            addCriterion("idata2 <", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2LessThanOrEqualTo(Integer value) {
            addCriterion("idata2 <=", value, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2In(List<Integer> values) {
            addCriterion("idata2 in", values, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2NotIn(List<Integer> values) {
            addCriterion("idata2 not in", values, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2Between(Integer value1, Integer value2) {
            addCriterion("idata2 between", value1, value2, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata2NotBetween(Integer value1, Integer value2) {
            addCriterion("idata2 not between", value1, value2, "idata2");
            return (Criteria) this;
        }

        public Criteria andIdata3IsNull() {
            addCriterion("idata3 is null");
            return (Criteria) this;
        }

        public Criteria andIdata3IsNotNull() {
            addCriterion("idata3 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata3EqualTo(Integer value) {
            addCriterion("idata3 =", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3NotEqualTo(Integer value) {
            addCriterion("idata3 <>", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3GreaterThan(Integer value) {
            addCriterion("idata3 >", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3GreaterThanOrEqualTo(Integer value) {
            addCriterion("idata3 >=", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3LessThan(Integer value) {
            addCriterion("idata3 <", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3LessThanOrEqualTo(Integer value) {
            addCriterion("idata3 <=", value, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3In(List<Integer> values) {
            addCriterion("idata3 in", values, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3NotIn(List<Integer> values) {
            addCriterion("idata3 not in", values, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3Between(Integer value1, Integer value2) {
            addCriterion("idata3 between", value1, value2, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata3NotBetween(Integer value1, Integer value2) {
            addCriterion("idata3 not between", value1, value2, "idata3");
            return (Criteria) this;
        }

        public Criteria andIdata4IsNull() {
            addCriterion("idata4 is null");
            return (Criteria) this;
        }

        public Criteria andIdata4IsNotNull() {
            addCriterion("idata4 is not null");
            return (Criteria) this;
        }

        public Criteria andIdata4EqualTo(Integer value) {
            addCriterion("idata4 =", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4NotEqualTo(Integer value) {
            addCriterion("idata4 <>", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4GreaterThan(Integer value) {
            addCriterion("idata4 >", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4GreaterThanOrEqualTo(Integer value) {
            addCriterion("idata4 >=", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4LessThan(Integer value) {
            addCriterion("idata4 <", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4LessThanOrEqualTo(Integer value) {
            addCriterion("idata4 <=", value, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4In(List<Integer> values) {
            addCriterion("idata4 in", values, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4NotIn(List<Integer> values) {
            addCriterion("idata4 not in", values, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4Between(Integer value1, Integer value2) {
            addCriterion("idata4 between", value1, value2, "idata4");
            return (Criteria) this;
        }

        public Criteria andIdata4NotBetween(Integer value1, Integer value2) {
            addCriterion("idata4 not between", value1, value2, "idata4");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("UpdateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("UpdateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("UpdateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UpdateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("UpdateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("UpdateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("UpdateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("UpdateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("UpdateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("UpdateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}